
		**********************************************************
		** File: cleaning_Cho_et_al_2013.do						**
		** Paper: Human Trafficking Indicators: A New Dataset	**
		** Author: Richard Frank								**
		** Date: July 11, 2021									**
		** Task: cleaning Cho Dreher and Neumayer (2013)		**
		**********************************************************

 
	clear
	version 16.1
	set seed 1234
	
	cd "~"
		
	* data source: https://ericneumayer.wordpress.com/publications-chronologically-ordered/
	
	use "Cho-Dreher-Neumayer-WD-replication.dta", clear
	
	mi extract 0
	keep country year prostitutionlaw prostitutionbrothel
	rename country Country
	run "cow.do"
	tab Country if ccode==0
	drop if ccode==0
	rename Country country
	duplicates report ccode year
	sort ccode year
	browse if ccode==ccode[_n-1] & year==year[_n-1]
	browse if ccode==710
	drop if country=="Hong Kong, China"
	order ccode

	save "Cho_pros.dta", replace
	
	
	
